Profiling Report

Dataset statistics

Number of variables	40
Number of observations	4882
Missing cells	8951
Missing cells (%)	4.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.5 MiB
Average record size in memory	320.0 B

Variable types

Numeric	30
Categorical	10

Alerts

`indfmt` has constant value ""	Constant
`consol` has constant value ""	Constant
`popsrc` has constant value ""	Constant
`datafmt` has constant value ""	Constant
`curcd` has constant value ""	Constant
`costat` has constant value ""	Constant
`datadate` has a high cardinality: 121 distinct values	High cardinality
`tic` has a high cardinality: 498 distinct values	High cardinality
`cusip` has a high cardinality: 498 distinct values	High cardinality
`conm` has a high cardinality: 498 distinct values	High cardinality
`gvkey` is highly overall correlated with `cik`	High correlation
`act` is highly overall correlated with `at` and 17 other fields	High correlation
`at` is highly overall correlated with `act` and 16 other fields	High correlation
`bkvlps` is highly overall correlated with `ceql` and 2 other fields	High correlation
`capx` is highly overall correlated with `act` and 15 other fields	High correlation
`ceql` is highly overall correlated with `act` and 16 other fields	High correlation
`csho` is highly overall correlated with `act` and 16 other fields	High correlation
`dltt` is highly overall correlated with `act` and 15 other fields	High correlation
`dt` is highly overall correlated with `act` and 16 other fields	High correlation
`dvp` is highly overall correlated with `pstkl`	High correlation
`ebitda` is highly overall correlated with `act` and 16 other fields	High correlation
`emp` is highly overall correlated with `act` and 12 other fields	High correlation
`lct` is highly overall correlated with `act` and 16 other fields	High correlation
`lt` is highly overall correlated with `act` and 16 other fields	High correlation
`ni` is highly overall correlated with `act` and 15 other fields	High correlation
`ppegt` is highly overall correlated with `act` and 16 other fields	High correlation
`pstkl` is highly overall correlated with `dvp`	High correlation
`revt` is highly overall correlated with `act` and 16 other fields	High correlation
`seq` is highly overall correlated with `act` and 16 other fields	High correlation
`teq` is highly overall correlated with `act` and 16 other fields	High correlation
`xad` is highly overall correlated with `act` and 16 other fields	High correlation
`xrd` is highly overall correlated with `act`	High correlation
`cik` is highly overall correlated with `gvkey`	High correlation
`mkvalt` is highly overall correlated with `act` and 16 other fields	High correlation
`act` has 864 (17.7%) missing values	Missing
`bkvlps` has 70 (1.4%) missing values	Missing
`csho` has 69 (1.4%) missing values	Missing
`dt` has 548 (11.2%) missing values	Missing
`ebitda` has 264 (5.4%) missing values	Missing
`emp` has 71 (1.5%) missing values	Missing
`lct` has 860 (17.6%) missing values	Missing
`ppegt` has 522 (10.7%) missing values	Missing
`xad` has 2720 (55.7%) missing values	Missing
`xrd` has 2053 (42.1%) missing values	Missing
`dvpsp_f` has 93 (1.9%) missing values	Missing
`mkvalt` has 401 (8.2%) missing values	Missing
`prcc_f` has 106 (2.2%) missing values	Missing
`bkvlps` is highly skewed (γ1 = 47.36237195)	Skewed
`tic` is uniformly distributed	Uniform
`cusip` is uniformly distributed	Uniform
`conm` is uniformly distributed	Uniform
`capx` has 309 (6.3%) zeros	Zeros
`dltt` has 258 (5.3%) zeros	Zeros
`dt` has 237 (4.9%) zeros	Zeros
`dvp` has 4213 (86.3%) zeros	Zeros
`pstkl` has 4147 (84.9%) zeros	Zeros
`xrd` has 651 (13.3%) zeros	Zeros
`dvpsp_f` has 1110 (22.7%) zeros	Zeros

Reproduction

Analysis started	2023-05-08 04:16:06.635156
Analysis finished	2023-05-08 04:17:33.281181
Duration	1 minute and 26.65 seconds
Software version	ydata-profiling vv4.0.0
Download configuration	config.json

gvkey
Real number (ℝ)

Distinct	498
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46174.04

Minimum	1045
Maximum	316056
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	1045
5-th percentile	2019
Q1	6268
median	12587.5
Q3	63172
95-th percentile	177267
Maximum	316056
Range	315011
Interquartile range (IQR)	56904

Descriptive statistics

Standard deviation	61447.241
Coefficient of variation (CV)	1.3307746
Kurtosis	1.0336797
Mean	46174.04
Median Absolute Deviation (MAD)	9770.5
Skewness	1.4633294
Sum	2.2542166 × 10⁸
Variance	3.7757634 × 10⁹
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6502	11	0.2%
11259	11	0.2%
3813	11	0.2%
141913	11	0.2%
9248	11	0.2%
157855	11	0.2%
162129	11	0.2%
165123	11	0.2%
117768	11	0.2%
2184	11	0.2%
Other values (488)	4772	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1045	10	0.2%
1075	10	0.2%
1078	10	0.2%
1161	10	0.2%
1209	10	0.2%
1230	10	0.2%
1300	10	0.2%
1327	10	0.2%
1380	10	0.2%
1440	10	0.2%

Value	Count	Frequency (%)
316056	9	0.2%
294524	10	0.2%
260774	10	0.2%
189491	10	0.2%
187697	10	0.2%
187450	10	0.2%
186989	10	0.2%
186310	10	0.2%
185532	10	0.2%
184996	10	0.2%

datadate
Categorical

Distinct	121
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Memory size	38.3 KiB

2019-12-31	386
2018-12-31	384
2017-12-31	384
2016-12-31	382
2015-12-31	379
Other values (116)	2967

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	48820
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2010-12-31
2nd row	2011-12-31
3rd row	2012-12-31
4th row	2013-12-31
5th row	2014-12-31

Common Values

Value	Count	Frequency (%)
2019-12-31	386	7.9%
2018-12-31	384	7.9%
2017-12-31	384	7.9%
2016-12-31	382	7.8%
2015-12-31	379	7.8%
2014-12-31	373	7.6%
2013-12-31	370	7.6%
2012-12-31	361	7.4%
2011-12-31	357	7.3%
2010-12-31	354	7.3%
Other values (111)	1152	23.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2019-12-31	386	7.9%
2017-12-31	384	7.9%
2018-12-31	384	7.9%
2016-12-31	382	7.8%
2015-12-31	379	7.8%
2014-12-31	373	7.6%
2013-12-31	370	7.6%
2012-12-31	361	7.4%
2011-12-31	357	7.3%
2010-12-31	354	7.3%
Other values (111)	1152	23.6%

Most occurring characters

Value	Count	Frequency (%)
1	13740	28.1%
-	9764	20.0%
2	9149	18.7%
0	7030	14.4%
3	5435	11.1%
9	751	1.5%
6	718	1.5%
5	592	1.2%
8	573	1.2%
7	536	1.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39056	80.0%
Dash Punctuation	9764	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	13740	35.2%
2	9149	23.4%
0	7030	18.0%
3	5435	13.9%
9	751	1.9%
6	718	1.8%
5	592	1.5%
8	573	1.5%
7	536	1.4%
4	532	1.4%

Dash Punctuation

Value	Count	Frequency (%)
-	9764	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	48820	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	13740	28.1%
-	9764	20.0%
2	9149	18.7%
0	7030	14.4%
3	5435	11.1%
9	751	1.5%
6	718	1.5%
5	592	1.2%
8	573	1.2%
7	536	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	48820	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	13740	28.1%
-	9764	20.0%
2	9149	18.7%
0	7030	14.4%
3	5435	11.1%
9	751	1.5%
6	718	1.5%
5	592	1.2%
8	573	1.2%
7	536	1.1%

fyear
Real number (ℝ)

Distinct	11
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2014.49

Minimum	2009
Maximum	2019
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	2009
5-th percentile	2010
Q1	2012
median	2015
Q3	2017
95-th percentile	2019
Maximum	2019
Range	10
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.8865742
Coefficient of variation (CV)	0.0014329057
Kurtosis	-1.195576
Mean	2014.49
Median Absolute Deviation (MAD)	2
Skewness	-0.031825149
Sum	9834740
Variance	8.3323106
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
2017	496	10.2%
2018	496	10.2%
2016	495	10.1%
2015	493	10.1%
2014	488	10.0%
2013	484	9.9%
2012	477	9.8%
2019	473	9.7%
2011	471	9.6%
2010	468	9.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2009	41	0.8%
2010	468	9.6%
2011	471	9.6%
2012	477	9.8%
2013	484	9.9%
2014	488	10.0%
2015	493	10.1%
2016	495	10.1%
2017	496	10.2%
2018	496	10.2%

Value	Count	Frequency (%)
2019	473	9.7%
2018	496	10.2%
2017	496	10.2%
2016	495	10.1%
2015	493	10.1%
2014	488	10.0%
2013	484	9.9%
2012	477	9.8%
2011	471	9.6%
2010	468	9.6%

indfmt
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	38.3 KiB

INDL	4882

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	19528
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	INDL
2nd row	INDL
3rd row	INDL
4th row	INDL
5th row	INDL

Common Values

Value	Count	Frequency (%)
INDL	4882	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
indl	4882	100.0%

Most occurring characters

Value	Count	Frequency (%)
I	4882	25.0%
N	4882	25.0%
D	4882	25.0%
L	4882	25.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	19528	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	4882	25.0%
N	4882	25.0%
D	4882	25.0%
L	4882	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	19528	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	4882	25.0%
N	4882	25.0%
D	4882	25.0%
L	4882	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	19528	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	4882	25.0%
N	4882	25.0%
D	4882	25.0%
L	4882	25.0%

consol
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	38.3 KiB

C	4882

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	4882
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C
2nd row	C
3rd row	C
4th row	C
5th row	C

Common Values

Value	Count	Frequency (%)
C	4882	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
c	4882	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	4882	100.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4882	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	4882	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4882	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	4882	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4882	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	4882	100.0%

popsrc
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	38.3 KiB

D	4882

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	4882
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	D
2nd row	D
3rd row	D
4th row	D
5th row	D

Common Values

Value	Count	Frequency (%)
D	4882	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
d	4882	100.0%

Most occurring characters

Value	Count	Frequency (%)
D	4882	100.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4882	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	4882	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4882	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	4882	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4882	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	4882	100.0%

datafmt
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	38.3 KiB

STD	4882

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	14646
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	STD
2nd row	STD
3rd row	STD
4th row	STD
5th row	STD

Common Values

Value	Count	Frequency (%)
STD	4882	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
std	4882	100.0%

Most occurring characters

Value	Count	Frequency (%)
S	4882	33.3%
T	4882	33.3%
D	4882	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	14646	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	4882	33.3%
T	4882	33.3%
D	4882	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14646	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	4882	33.3%
T	4882	33.3%
D	4882	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14646	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	4882	33.3%
T	4882	33.3%
D	4882	33.3%

tic
Categorical

HIGH CARDINALITY UNIFORM

Distinct	498
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Memory size	38.3 KiB

KR	11
WMT	11
TGT	11
GPN	11
ROST	11
Other values (493)	4827

Length

Max length	5
Median length	3
Mean length	3.1519869
Min length	1

Characters and Unicode

Total characters	15388
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	AAL
2nd row	AAL
3rd row	AAL
4th row	AAL
5th row	AAL

Common Values

Value	Count	Frequency (%)
KR	11	0.2%
WMT	11	0.2%
TGT	11	0.2%
GPN	11	0.2%
ROST	11	0.2%
CRM	11	0.2%
MOS	11	0.2%
LDOS	11	0.2%
NVDA	11	0.2%
BBY	11	0.2%
Other values (488)	4772	97.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
kr	11	0.2%
dltr	11	0.2%
wmt	11	0.2%
tjx	11	0.2%
low	11	0.2%
bbwi	11	0.2%
adsk	11	0.2%
hd	11	0.2%
ulta	11	0.2%
khc	11	0.2%
Other values (488)	4772	97.7%

Most occurring characters

Value	Count	Frequency (%)
A	1120	7.3%
C	1089	7.1%
T	979	6.4%
M	929	6.0%
S	925	6.0%
R	860	5.6%
L	834	5.4%
P	790	5.1%
E	786	5.1%
N	749	4.9%
Other values (17)	6327	41.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	15368	99.9%
Other Punctuation	20	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1120	7.3%
C	1089	7.1%
T	979	6.4%
M	929	6.0%
S	925	6.0%
R	860	5.6%
L	834	5.4%
P	790	5.1%
E	786	5.1%
N	749	4.9%
Other values (16)	6307	41.0%

Other Punctuation

Value	Count	Frequency (%)
.	20	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15368	99.9%
Common	20	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1120	7.3%
C	1089	7.1%
T	979	6.4%
M	929	6.0%
S	925	6.0%
R	860	5.6%
L	834	5.4%
P	790	5.1%
E	786	5.1%
N	749	4.9%
Other values (16)	6307	41.0%

Common

Value	Count	Frequency (%)
.	20	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15388	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1120	7.3%
C	1089	7.1%
T	979	6.4%
M	929	6.0%
S	925	6.0%
R	860	5.6%
L	834	5.4%
P	790	5.1%
E	786	5.1%
N	749	4.9%
Other values (17)	6327	41.1%

cusip
Categorical

HIGH CARDINALITY UNIFORM

Distinct	498
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Memory size	38.3 KiB

501044101	11
931142103	11
87612E106	11
37940X102	11
778296103	11
Other values (493)	4827

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	43938
Distinct characters	33
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	02376R102
2nd row	02376R102
3rd row	02376R102
4th row	02376R102
5th row	02376R102

Common Values

Value	Count	Frequency (%)
501044101	11	0.2%
931142103	11	0.2%
87612E106	11	0.2%
37940X102	11	0.2%
778296103	11	0.2%
79466L302	11	0.2%
61945C103	11	0.2%
525327102	11	0.2%
67066G104	11	0.2%
086516101	11	0.2%
Other values (488)	4772	97.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
501044101	11	0.2%
256746108	11	0.2%
931142103	11	0.2%
872540109	11	0.2%
548661107	11	0.2%
070830104	11	0.2%
052769106	11	0.2%
437076102	11	0.2%
90384s303	11	0.2%
500754106	11	0.2%
Other values (488)	4772	97.7%

Most occurring characters

Value	Count	Frequency (%)
0	8518	19.4%
1	7952	18.1%
4	3472	7.9%
2	3383	7.7%
3	3350	7.6%
5	3257	7.4%
6	3220	7.3%
7	2905	6.6%
9	2853	6.5%
8	2828	6.4%
Other values (23)	2200	5.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	41738	95.0%
Uppercase Letter	2200	5.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	283	12.9%
L	170	7.7%
V	134	6.1%
C	132	6.0%
R	130	5.9%
E	121	5.5%
T	120	5.5%
P	120	5.5%
X	111	5.0%
H	100	4.5%
Other values (13)	779	35.4%

Decimal Number

Value	Count	Frequency (%)
0	8518	20.4%
1	7952	19.1%
4	3472	8.3%
2	3383	8.1%
3	3350	8.0%
5	3257	7.8%
6	3220	7.7%
7	2905	7.0%
9	2853	6.8%
8	2828	6.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	41738	95.0%
Latin	2200	5.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	283	12.9%
L	170	7.7%
V	134	6.1%
C	132	6.0%
R	130	5.9%
E	121	5.5%
T	120	5.5%
P	120	5.5%
X	111	5.0%
H	100	4.5%
Other values (13)	779	35.4%

Common

Value	Count	Frequency (%)
0	8518	20.4%
1	7952	19.1%
4	3472	8.3%
2	3383	8.1%
3	3350	8.0%
5	3257	7.8%
6	3220	7.7%
7	2905	7.0%
9	2853	6.8%
8	2828	6.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43938	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	8518	19.4%
1	7952	18.1%
4	3472	7.9%
2	3383	7.7%
3	3350	7.6%
5	3257	7.4%
6	3220	7.3%
7	2905	6.6%
9	2853	6.5%
8	2828	6.4%
Other values (23)	2200	5.0%

conm
Categorical

HIGH CARDINALITY UNIFORM

Distinct	498
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Memory size	38.3 KiB

KROGER CO	11
WALMART INC	11
TARGET CORP	11
GLOBAL PAYMENTS INC	11
ROSS STORES INC	11
Other values (493)	4827

Length

Max length	28
Median length	21
Mean length	17.226137
Min length	5

Characters and Unicode

Total characters	84098
Distinct characters	37
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	AMERICAN AIRLINES GROUP INC
2nd row	AMERICAN AIRLINES GROUP INC
3rd row	AMERICAN AIRLINES GROUP INC
4th row	AMERICAN AIRLINES GROUP INC
5th row	AMERICAN AIRLINES GROUP INC

Common Values

Value	Count	Frequency (%)
KROGER CO	11	0.2%
WALMART INC	11	0.2%
TARGET CORP	11	0.2%
GLOBAL PAYMENTS INC	11	0.2%
ROSS STORES INC	11	0.2%
SALESFORCE INC	11	0.2%
MOSAIC CO	11	0.2%
LEIDOS HOLDINGS INC	11	0.2%
NVIDIA CORP	11	0.2%
BEST BUY CO INC	11	0.2%
Other values (488)	4772	97.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
inc	2501	18.2%
corp	1124	8.2%
co	471	3.4%
group	228	1.7%
	212	1.5%
energy	180	1.3%
plc	139	1.0%
financial	136	1.0%
technologies	125	0.9%
holdings	114	0.8%
Other values (703)	8522	62.0%

Most occurring characters

Value	Count	Frequency (%)
	8900	10.6%
C	7452	8.9%
N	7331	8.7%
I	6905	8.2%
E	6580	7.8%
O	6289	7.5%
R	6062	7.2%
A	5138	6.1%
T	4118	4.9%
S	4100	4.9%
Other values (27)	21223	25.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	74317	88.4%
Space Separator	8900	10.6%
Other Punctuation	353	0.4%
Dash Punctuation	196	0.2%
Open Punctuation	141	0.2%
Close Punctuation	141	0.2%
Decimal Number	50	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	7452	10.0%
N	7331	9.9%
I	6905	9.3%
E	6580	8.9%
O	6289	8.5%
R	6062	8.2%
A	5138	6.9%
T	4118	5.5%
S	4100	5.5%
L	3778	5.1%
Other values (16)	16564	22.3%

Other Punctuation

Value	Count	Frequency (%)
&	242	68.6%
'	51	14.4%
.	40	11.3%
/	20	5.7%

Decimal Number

Value	Count	Frequency (%)
6	20	40.0%
3	20	40.0%
5	10	20.0%

Space Separator

Value	Count	Frequency (%)
	8900	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	196	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	141	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	141	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	74317	88.4%
Common	9781	11.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	7452	10.0%
N	7331	9.9%
I	6905	9.3%
E	6580	8.9%
O	6289	8.5%
R	6062	8.2%
A	5138	6.9%
T	4118	5.5%
S	4100	5.5%
L	3778	5.1%
Other values (16)	16564	22.3%

Common

Value	Count	Frequency (%)
	8900	91.0%
&	242	2.5%
-	196	2.0%
(	141	1.4%
)	141	1.4%
'	51	0.5%
.	40	0.4%
/	20	0.2%
6	20	0.2%
3	20	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84098	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	8900	10.6%
C	7452	8.9%
N	7331	8.7%
I	6905	8.2%
E	6580	7.8%
O	6289	7.5%
R	6062	7.2%
A	5138	6.1%
T	4118	4.9%
S	4100	4.9%
Other values (27)	21223	25.2%

curcd
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	38.3 KiB

USD	4882

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	14646
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	USD
2nd row	USD
3rd row	USD
4th row	USD
5th row	USD

Common Values

Value	Count	Frequency (%)
USD	4882	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
usd	4882	100.0%

Most occurring characters

Value	Count	Frequency (%)
U	4882	33.3%
S	4882	33.3%
D	4882	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	14646	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
U	4882	33.3%
S	4882	33.3%
D	4882	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14646	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
U	4882	33.3%
S	4882	33.3%
D	4882	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14646	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
U	4882	33.3%
S	4882	33.3%
D	4882	33.3%

fyr
Real number (ℝ)

Distinct	12
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.624334

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	12
median	12
Q3	12
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.897732
Coefficient of variation (CV)	0.27274481
Kurtosis	3.3461639
Mean	10.624334
Median Absolute Deviation (MAD)	0
Skewness	-2.113947
Sum	51868
Variance	8.3968509
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
12	3730	76.4%
9	248	5.1%
6	222	4.5%
1	168	3.4%
10	115	2.4%
5	98	2.0%
3	90	1.8%
8	60	1.2%
4	44	0.9%
11	44	0.9%
Other values (2)	63	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	168	3.4%
2	23	0.5%
3	90	1.8%
4	44	0.9%
5	98	2.0%
6	222	4.5%
7	40	0.8%
8	60	1.2%
9	248	5.1%
10	115	2.4%

Value	Count	Frequency (%)
12	3730	76.4%
11	44	0.9%
10	115	2.4%
9	248	5.1%
8	60	1.2%
7	40	0.8%
6	222	4.5%
5	98	2.0%
4	44	0.9%
3	90	1.8%

act
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	3933
Distinct (%)	97.9%
Missing	864
Missing (%)	17.7%
Infinite	0
Infinite (%)	0.0%
Mean	8405.045

Minimum	25.037
Maximum	175552
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	25.037
5-th percentile	511.6895
Q1	1581.8093
median	3325.052
Q3	8251.25
95-th percentile	34450.7
Maximum	175552
Range	175526.96
Interquartile range (IQR)	6669.4407

Descriptive statistics

Standard deviation	14911.298
Coefficient of variation (CV)	1.774089
Kurtosis	30.076035
Mean	8405.045
Median Absolute Deviation (MAD)	2255.3515
Skewness	4.6199071
Sum	33771471
Variance	2.223468 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1527	3	0.1%
13704	2	< 0.1%
2730	2	< 0.1%
3507	2	< 0.1%
2971.9	2	< 0.1%
3033	2	< 0.1%
4404	2	< 0.1%
3836	2	< 0.1%
3465	2	< 0.1%
10566	2	< 0.1%
Other values (3923)	3997	81.9%
(Missing)	864	17.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
25.037	1	< 0.1%
30.933	1	< 0.1%
44.173	1	< 0.1%
47.492	1	< 0.1%
50.275	1	< 0.1%
52.956	1	< 0.1%
61.968	1	< 0.1%
66.025	1	< 0.1%
69.273	1	< 0.1%
76.785	1	< 0.1%

Value	Count	Frequency (%)
175552	1	< 0.1%
169662	1	< 0.1%
162819	1	< 0.1%
159851	1	< 0.1%
152578	1	< 0.1%
139660	1	< 0.1%
135676	1	< 0.1%
131339	1	< 0.1%
128645	1	< 0.1%
124712	1	< 0.1%

at
Real number (ℝ)

Distinct	4833
Distinct (%)	99.5%
Missing	23
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	62633.461

Minimum	49.086
Maximum	2687379
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	49.086
5-th percentile	1589.575
Q1	5876.451
median	15647.066
Q3	40319.5
95-th percentile	221765.9
Maximum	2687379
Range	2687329.9
Interquartile range (IQR)	34443.049

Descriptive statistics

Standard deviation	209674.28
Coefficient of variation (CV)	3.34764
Kurtosis	76.883658
Mean	62633.461
Median Absolute Deviation (MAD)	11797.534
Skewness	8.1601373
Sum	3.0433599 × 10⁸
Variance	4.3963304 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20497	2	< 0.1%
18174	2	< 0.1%
34309	2	< 0.1%
20386	2	< 0.1%
6184	2	< 0.1%
13459	2	< 0.1%
20038	2	< 0.1%
6262	2	< 0.1%
45058	2	< 0.1%
121347	2	< 0.1%
Other values (4823)	4839	99.1%
(Missing)	23	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
49.086	1	< 0.1%
51.369	1	< 0.1%
59.504	1	< 0.1%
74.998	1	< 0.1%
77.164	1	< 0.1%
106	1	< 0.1%
106.159	1	< 0.1%
106.242	1	< 0.1%
108.746	1	< 0.1%
116.669	1	< 0.1%

Value	Count	Frequency (%)
2687379	1	< 0.1%
2622532	1	< 0.1%
2573126	1	< 0.1%
2533600	1	< 0.1%
2490972	1	< 0.1%
2434079	1	< 0.1%
2415689	1	< 0.1%
2359141	1	< 0.1%
2354507	1	< 0.1%
2351698	1	< 0.1%

bkvlps
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED

Distinct	4795
Distinct (%)	99.6%
Missing	70
Missing (%)	1.4%
Infinite	0
Infinite (%)	0.0%
Mean	7929.4908

Minimum	-125.6877
Maximum	16297416
Zeros	0
Zeros (%)	0.0%
Negative	182
Negative (%)	3.7%
Memory size	38.3 KiB

Quantile statistics

Minimum	-125.6877
5-th percentile	1.519805
Q1	9.953625
median	18.384
Q3	32.573475
95-th percentile	72.674025
Maximum	16297416
Range	16297542
Interquartile range (IQR)	22.61985

Descriptive statistics

Standard deviation	327827.78
Coefficient of variation (CV)	41.342855
Kurtosis	2288.1667
Mean	7929.4908
Median Absolute Deviation (MAD)	10.1635
Skewness	47.362372
Sum	38156710
Variance	1.0747106 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23.3468	2	< 0.1%
10.3063	2	< 0.1%
12.9776	2	< 0.1%
5.9736	2	< 0.1%
5.4405	2	< 0.1%
7.7707	2	< 0.1%
60.1364	2	< 0.1%
21.4568	2	< 0.1%
19.8094	2	< 0.1%
21.4275	2	< 0.1%
Other values (4785)	4792	98.2%
(Missing)	70	1.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-125.6877	1	< 0.1%
-87.732	1	< 0.1%
-74.1842	1	< 0.1%
-71.2976	1	< 0.1%
-70.1814	1	< 0.1%
-63.7648	1	< 0.1%
-61.3894	1	< 0.1%
-59.0613	1	< 0.1%
-56.826	1	< 0.1%
-55.494	1	< 0.1%

Value	Count	Frequency (%)
16297416	1	< 0.1%
15437843	1	< 0.1%
2455471	1	< 0.1%
1956293	1	< 0.1%
1885901	1	< 0.1%
644.4382	1	< 0.1%
505.4673	1	< 0.1%
434.9748	1	< 0.1%
353.2199	1	< 0.1%
325.8986	1	< 0.1%

capx
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	3888
Distinct (%)	80.2%
Missing	33
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	1241.3741

Minimum	0
Maximum	37985
Zeros	309
Zeros (%)	6.3%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	83.435
median	280.873
Q3	1113
95-th percentile	5164.8
Maximum	37985
Range	37985
Interquartile range (IQR)	1029.565

Descriptive statistics

Standard deviation	2924.7561
Coefficient of variation (CV)	2.3560635
Kurtosis	44.020255
Mean	1241.3741
Median Absolute Deviation (MAD)	255.191
Skewness	5.7506115
Sum	6019422.9
Variance	8554198.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	309	6.3%
145	7	0.1%
121	7	0.1%
593	7	0.1%
180	7	0.1%
119	7	0.1%
162	7	0.1%
246	6	0.1%
224	5	0.1%
422	5	0.1%
Other values (3878)	4482	91.8%
(Missing)	33	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	309	6.3%
0.42	1	< 0.1%
0.899	1	< 0.1%
1.384	1	< 0.1%
1.506	1	< 0.1%
1.539	1	< 0.1%
1.584	1	< 0.1%
1.945	1	< 0.1%
2.031	1	< 0.1%
2.2	1	< 0.1%

Value	Count	Frequency (%)
37985	1	< 0.1%
35407	1	< 0.1%
34271	1	< 0.1%
33669	1	< 0.1%
32952	1	< 0.1%
30975	1	< 0.1%
30938	1	< 0.1%
29504	1	< 0.1%
29166	1	< 0.1%
27633	1	< 0.1%

ceql
Real number (ℝ)

Distinct	4785
Distinct (%)	98.5%
Missing	24
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	13133.283

Minimum	-13244
Maximum	424791
Zeros	0
Zeros (%)	0.0%
Negative	182
Negative (%)	3.7%
Memory size	38.3 KiB

Quantile statistics

Minimum	-13244
5-th percentile	187.0476
Q1	1955.957
median	4995.85
Q3	11724.797
95-th percentile	51662.85
Maximum	424791
Range	438035
Interquartile range (IQR)	9768.84

Descriptive statistics

Standard deviation	28367.252
Coefficient of variation (CV)	2.1599514
Kurtosis	41.736409
Mean	13133.283
Median Absolute Deviation (MAD)	3681.3425
Skewness	5.6140678
Sum	63801487
Variance	8.0470099 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23771	2	< 0.1%
5488	2	< 0.1%
4752	2	< 0.1%
1145	2	< 0.1%
-60	2	< 0.1%
-102	2	< 0.1%
1454	2	< 0.1%
7336	2	< 0.1%
8380	2	< 0.1%
1045.5	2	< 0.1%
Other values (4775)	4838	99.1%
(Missing)	24	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-13244	1	< 0.1%
-12688	1	< 0.1%
-12629	1	< 0.1%
-12459	1	< 0.1%
-12086	1	< 0.1%
-11926	1	< 0.1%
-11577	1	< 0.1%
-9660	1	< 0.1%
-8617	1	< 0.1%
-8446	1	< 0.1%

Value	Count	Frequency (%)
424791	1	< 0.1%
348703	1	< 0.1%
348296	1	< 0.1%
283001	1	< 0.1%
255550	1	< 0.1%
244823	1	< 0.1%
242999	1	< 0.1%
241620	1	< 0.1%
241409	1	< 0.1%
240170	1	< 0.1%

csho
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	4641
Distinct (%)	96.4%
Missing	69
Missing (%)	1.4%
Infinite	0
Infinite (%)	0.0%
Mean	597.31446

Minimum	0.001
Maximum	29058.361
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	0.001
5-th percentile	47.3654
Q1	129.954
median	281
Q3	561
95-th percentile	2098.8932
Maximum	29058.361
Range	29058.36
Interquartile range (IQR)	431.046

Descriptive statistics

Standard deviation	1161.9103
Coefficient of variation (CV)	1.9452238
Kurtosis	98.837772
Mean	597.31446
Median Absolute Deviation (MAD)	174
Skewness	7.1858145
Sum	2874874.5
Variance	1350035.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
325.811	9	0.2%
242.6	7	0.1%
0.001	5	0.1%
333	4	0.1%
321	4	0.1%
418	3	0.1%
147	3	0.1%
776	3	0.1%
585	3	0.1%
967	3	0.1%
Other values (4631)	4769	97.7%
(Missing)	69	1.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.001	5	0.1%
0.271	2	< 0.1%
0.843	1	< 0.1%
1.011	1	< 0.1%
1.013	1	< 0.1%
1.015	1	< 0.1%
1.698	1	< 0.1%
2.782	1	< 0.1%
2.81	1	< 0.1%
3.578	1	< 0.1%

Value	Count	Frequency (%)
29058.361	1	< 0.1%
10778.264	1	< 0.1%
10615.376	1	< 0.1%
10591.808	1	< 0.1%
10573.017	1	< 0.1%
10535.938	1	< 0.1%
10516.542	1	< 0.1%
10405.625	1	< 0.1%
10380.265	1	< 0.1%
10287.302	1	< 0.1%

dltt
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	4407
Distinct (%)	91.0%
Missing	40
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	10426.34

Minimum	0
Maximum	359180
Zeros	258
Zeros (%)	5.3%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1108.1715
median	3662.1
Q3	9365.4837
95-th percentile	33532.5
Maximum	359180
Range	359180
Interquartile range (IQR)	8257.3122

Descriptive statistics

Standard deviation	26635.715
Coefficient of variation (CV)	2.5546562
Kurtosis	53.936952
Mean	10426.34
Median Absolute Deviation (MAD)	3057.862
Skewness	6.7206404
Sum	50484339
Variance	7.0946131 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	258	5.3%
250	13	0.3%
500	8	0.2%
150	7	0.1%
499	4	0.1%
799	3	0.1%
3935	3	0.1%
575	3	0.1%
750	3	0.1%
1099	3	0.1%
Other values (4397)	4537	92.9%
(Missing)	40	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	258	5.3%
0.018	1	< 0.1%
0.022	1	< 0.1%
0.038	1	< 0.1%
0.193	1	< 0.1%
0.349	1	< 0.1%
0.457	1	< 0.1%
0.485	1	< 0.1%
0.509	1	< 0.1%
0.648	1	< 0.1%

Value	Count	Frequency (%)
359180	1	< 0.1%
324782	1	< 0.1%
309710	1	< 0.1%
279618	1	< 0.1%
274873	1	< 0.1%
274850	1	< 0.1%
271245	1	< 0.1%
268676	1	< 0.1%
268522	1	< 0.1%
266303	1	< 0.1%

dt
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	3959
Distinct (%)	91.3%
Missing	548
Missing (%)	11.2%
Infinite	0
Infinite (%)	0.0%
Mean	9866.0364

Minimum	0
Maximum	426314
Zeros	237
Zeros (%)	4.9%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1033.7673
median	3395.356
Q3	8691.365
95-th percentile	32392
Maximum	426314
Range	426314
Interquartile range (IQR)	7657.5977

Descriptive statistics

Standard deviation	26541.057
Coefficient of variation (CV)	2.6901438
Kurtosis	82.503456
Mean	9866.0364
Median Absolute Deviation (MAD)	2840.5
Skewness	8.0090617
Sum	42759402
Variance	7.044277 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	237	4.9%
250	9	0.2%
500	5	0.1%
150	5	0.1%
799	3	0.1%
827	3	0.1%
35	3	0.1%
1199	3	0.1%
12825	3	0.1%
6838	3	0.1%
Other values (3949)	4060	83.2%
(Missing)	548	11.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	237	4.9%
0.009	1	< 0.1%
0.033	1	< 0.1%
0.056	1	< 0.1%
0.2	1	< 0.1%
0.274	1	< 0.1%
0.338	1	< 0.1%
0.349	1	< 0.1%
0.509	1	< 0.1%
0.525	1	< 0.1%

Value	Count	Frequency (%)
426314	1	< 0.1%
398523	1	< 0.1%
381183	1	< 0.1%
362000	1	< 0.1%
344435	1	< 0.1%
333248	1	< 0.1%
323505	1	< 0.1%
273058	1	< 0.1%
272565	1	< 0.1%
259374	1	< 0.1%

dvp
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	411
Distinct (%)	8.5%
Missing	25
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	22.204622

Minimum	-112
Maximum	2018
Zeros	4213
Zeros (%)	86.3%
Negative	2
Negative (%)	< 0.1%
Memory size	38.3 KiB

Quantile statistics

Minimum	-112
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	73
Maximum	2018
Range	2130
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	134.4147
Coefficient of variation (CV)	6.053456
Kurtosis	99.483079
Mean	22.204622
Median Absolute Deviation (MAD)	0
Skewness	9.4181971
Sum	107847.85
Variance	18067.311
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4213	86.3%
1	20	0.4%
2	12	0.2%
14	12	0.2%
3.337	9	0.2%
340	8	0.2%
0.541	7	0.1%
10.5	6	0.1%
3	6	0.1%
10.2	6	0.1%
Other values (401)	558	11.4%
(Missing)	25	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-112	1	< 0.1%
-29	1	< 0.1%
0	4213	86.3%
0.008	1	< 0.1%
0.009	2	< 0.1%
0.012	2	< 0.1%
0.019	1	< 0.1%
0.03	5	0.1%
0.153	1	< 0.1%
0.224	2	< 0.1%

Value	Count	Frequency (%)
2018	1	< 0.1%
1932	1	< 0.1%
1704	1	< 0.1%
1682	1	< 0.1%
1663	1	< 0.1%
1647	1	< 0.1%
1629	1	< 0.1%
1614	1	< 0.1%
1611	1	< 0.1%
1587	1	< 0.1%

ebitda
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	4410
Distinct (%)	95.5%
Missing	264
Missing (%)	5.4%
Infinite	0
Infinite (%)	0.0%
Mean	4396.5382

Minimum	-21913
Maximum	115545
Zeros	0
Zeros (%)	0.0%
Negative	62
Negative (%)	1.3%
Memory size	38.3 KiB

Quantile statistics

Minimum	-21913
5-th percentile	203.3093
Q1	811
median	1842.65
Q3	4303.875
95-th percentile	17405.75
Maximum	115545
Range	137458
Interquartile range (IQR)	3492.875

Descriptive statistics

Standard deviation	8160.3083
Coefficient of variation (CV)	1.8560758
Kurtosis	29.223214
Mean	4396.5382
Median Absolute Deviation (MAD)	1280.1
Skewness	4.6450564
Sum	20303213
Variance	66590632
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4854	4	0.1%
2108	4	0.1%
811	3	0.1%
2113	3	0.1%
1684	3	0.1%
1088	3	0.1%
1221	3	0.1%
809	3	0.1%
2997	3	0.1%
3319	3	0.1%
Other values (4400)	4586	93.9%
(Missing)	264	5.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-21913	1	< 0.1%
-15891	1	< 0.1%
-9647	1	< 0.1%
-4171	1	< 0.1%
-3124	1	< 0.1%
-2185	1	< 0.1%
-2007	1	< 0.1%
-1792	1	< 0.1%
-927	1	< 0.1%
-666.676	1	< 0.1%

Value	Count	Frequency (%)
115545	1	< 0.1%
81730	1	< 0.1%
79962	1	< 0.1%
75230	1	< 0.1%
71565	1	< 0.1%
70744	1	< 0.1%
69687	1	< 0.1%
69276	1	< 0.1%
67089	1	< 0.1%
65769	1	< 0.1%

emp
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2853
Distinct (%)	59.3%
Missing	71
Missing (%)	1.5%
Infinite	0
Infinite (%)	0.0%
Mean	51.071399

Minimum	0.052
Maximum	2300
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	0.052
5-th percentile	1.215
Q1	7
median	17
Q3	50
95-th percentile	223.3575
Maximum	2300
Range	2299.948
Interquartile range (IQR)	43

Descriptive statistics

Standard deviation	128.09718
Coefficient of variation (CV)	2.5081979
Kurtosis	184.29779
Mean	51.071399
Median Absolute Deviation (MAD)	13.286
Skewness	11.594522
Sum	245704.5
Variance	16408.886
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	24	0.5%
30	23	0.5%
5	22	0.5%
14	22	0.5%
25	19	0.4%
24	19	0.4%
50	18	0.4%
22	18	0.4%
7	17	0.3%
35	17	0.3%
Other values (2843)	4612	94.5%
(Missing)	71	1.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.052	1	< 0.1%
0.068	1	< 0.1%
0.079	1	< 0.1%
0.083	1	< 0.1%
0.097	1	< 0.1%
0.114	1	< 0.1%
0.116	1	< 0.1%
0.125	1	< 0.1%
0.132	1	< 0.1%
0.14	3	0.1%

Value	Count	Frequency (%)
2300	3	0.1%
2200	6	0.1%
2100	2	< 0.1%
798	1	< 0.1%
647.5	1	< 0.1%
566	1	< 0.1%
539	1	< 0.1%
537	1	< 0.1%
523	1	< 0.1%
505	1	< 0.1%

lct
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	3904
Distinct (%)	97.1%
Missing	860
Missing (%)	17.6%
Infinite	0
Infinite (%)	0.0%
Mean	6214.9261

Minimum	13.203
Maximum	116866
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	13.203
5-th percentile	238.62265
Q1	933.992
median	2418.283
Q3	6052.5
95-th percentile	26616.55
Maximum	116866
Range	116852.8
Interquartile range (IQR)	5118.508

Descriptive statistics

Standard deviation	11160.336
Coefficient of variation (CV)	1.7957311
Kurtosis	22.712287
Mean	6214.9261
Median Absolute Deviation (MAD)	1812.6045
Skewness	4.2022502
Sum	24996433
Variance	1.245531 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5374	3	0.1%
2467	3	0.1%
3485	3	0.1%
12708	3	0.1%
1501	3	0.1%
2747	3	0.1%
2611	3	0.1%
2265	3	0.1%
3577	2	< 0.1%
3385	2	< 0.1%
Other values (3894)	3994	81.8%
(Missing)	860	17.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
13.203	1	< 0.1%
14.741	1	< 0.1%
15.129	1	< 0.1%
17.024	1	< 0.1%
18.188	1	< 0.1%
19.219	1	< 0.1%
19.5	1	< 0.1%
20.01	1	< 0.1%
23.46	1	< 0.1%
26.07	1	< 0.1%

Value	Count	Frequency (%)
116866	1	< 0.1%
105718	1	< 0.1%
100814	1	< 0.1%
98132	1	< 0.1%
97312	1	< 0.1%
95569	1	< 0.1%
94600	1	< 0.1%
90281	1	< 0.1%
87812	1	< 0.1%
85181	1	< 0.1%

lt
Real number (ℝ)

Distinct	4805
Distinct (%)	99.2%
Missing	37
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	48936.046

Minimum	15.985
Maximum	2426049
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	15.985
5-th percentile	597.4024
Q1	3348
median	9683.453
Q3	27430
95-th percentile	165172.6
Maximum	2426049
Range	2426033
Interquartile range (IQR)	24082

Descriptive statistics

Standard deviation	186723.4
Coefficient of variation (CV)	3.8156618
Kurtosis	81.014572
Mean	48936.046
Median Absolute Deviation (MAD)	7774.494
Skewness	8.4483769
Sum	2.3709514 × 10⁸
Variance	3.4865628 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13794	2	< 0.1%
34596	2	< 0.1%
3492	2	< 0.1%
47751	2	< 0.1%
2997.8	2	< 0.1%
16374	2	< 0.1%
56737	2	< 0.1%
14037	2	< 0.1%
14229	2	< 0.1%
6779	2	< 0.1%
Other values (4795)	4825	98.8%
(Missing)	37	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15.985	1	< 0.1%
16.171	1	< 0.1%
17.024	1	< 0.1%
21.023	1	< 0.1%
21.944	1	< 0.1%
28.868	1	< 0.1%
29	1	< 0.1%
30.99	1	< 0.1%
31.548	1	< 0.1%
34.708	1	< 0.1%

Value	Count	Frequency (%)
2426049	1	< 0.1%
2366017	1	< 0.1%
2341061	1	< 0.1%
2277907	1	< 0.1%
2236782	1	< 0.1%
2204511	1	< 0.1%
2169269	1	< 0.1%
2155072	1	< 0.1%
2104125	1	< 0.1%
2089182	1	< 0.1%

ni
Real number (ℝ)

Distinct	4477
Distinct (%)	92.2%
Missing	25
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	1920.1609

Minimum	-23119
Maximum	81417
Zeros	0
Zeros (%)	0.0%
Negative	342
Negative (%)	7.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	-23119
5-th percentile	-97.7168
Q1	286.198
median	704.422
Q3	1889
95-th percentile	8169.8
Maximum	81417
Range	104536
Interquartile range (IQR)	1602.802

Descriptive statistics

Standard deviation	4385.3296
Coefficient of variation (CV)	2.2838344
Kurtosis	59.008623
Mean	1920.1609
Median Absolute Deviation (MAD)	544.295
Skewness	5.8889373
Sum	9326221.7
Variance	19231116
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
263	4	0.1%
753	4	0.1%
591	4	0.1%
477	4	0.1%
1979	4	0.1%
858	4	0.1%
470	3	0.1%
242	3	0.1%
817	3	0.1%
563	3	0.1%
Other values (4467)	4821	98.8%
(Missing)	25	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-23119	1	< 0.1%
-22355	1	< 0.1%
-14454	1	< 0.1%
-12650	1	< 0.1%
-12236	1	< 0.1%
-10192	1	< 0.1%
-10137	1	< 0.1%
-7829	1	< 0.1%
-7642	1	< 0.1%
-6917.9	1	< 0.1%

Value	Count	Frequency (%)
81417	1	< 0.1%
59531	1	< 0.1%
55256	1	< 0.1%
53394	1	< 0.1%
48351	1	< 0.1%
45687	1	< 0.1%
44940	1	< 0.1%
44880	1	< 0.1%
41733	1	< 0.1%
41060	1	< 0.1%

ppegt
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	4278
Distinct (%)	98.1%
Missing	522
Missing (%)	10.7%
Infinite	0
Infinite (%)	0.0%
Mean	16275.383

Minimum	0
Maximum	493335
Zeros	9
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	0
5-th percentile	207.6715
Q1	1150
median	3925
Q3	16270.75
95-th percentile	61051.5
Maximum	493335
Range	493335
Interquartile range (IQR)	15120.75

Descriptive statistics

Standard deviation	38028.927
Coefficient of variation (CV)	2.3365919
Kurtosis	55.465276
Mean	16275.383
Median Absolute Deviation (MAD)	3406.88
Skewness	6.4634165
Sum	70960670
Variance	1.4461993 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9	0.2%
866	3	0.1%
1733	3	0.1%
1063	3	0.1%
1054	3	0.1%
2500	3	0.1%
2000	3	0.1%
858	2	< 0.1%
33686	2	< 0.1%
2139.3	2	< 0.1%
Other values (4268)	4327	88.6%
(Missing)	522	10.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	0.2%
2.348	1	< 0.1%
8.81	1	< 0.1%
9.3	1	< 0.1%
11.57	1	< 0.1%
12.146	1	< 0.1%
12.297	1	< 0.1%
13.552	1	< 0.1%
15.09	1	< 0.1%
21.774	1	< 0.1%

Value	Count	Frequency (%)
493335	1	< 0.1%
477190	1	< 0.1%
477185	1	< 0.1%
453915	1	< 0.1%
447337	1	< 0.1%
446789	1	< 0.1%
434517	1	< 0.1%
409314	1	< 0.1%
393995	1	< 0.1%
373938	1	< 0.1%

pstkl
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	390
Distinct (%)	8.0%
Missing	32
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	317.7737

Minimum	0
Maximum	49148
Zeros	4147
Zeros (%)	84.9%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1041.85
Maximum	49148
Range	49148
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2022.1028
Coefficient of variation (CV)	6.3633424
Kurtosis	154.19309
Mean	317.7737
Median Absolute Deviation (MAD)	0
Skewness	11.024392
Sum	1541202.4
Variance	4088899.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4147	84.9%
200	15	0.3%
325	11	0.2%
30.4	10	0.2%
39.847	10	0.2%
0.3	10	0.2%
142	10	0.2%
575	9	0.2%
155.6	8	0.2%
1000	8	0.2%
Other values (380)	612	12.5%
(Missing)	32	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4147	84.9%
0.015	3	0.1%
0.057	4	0.1%
0.058	2	< 0.1%
0.061	1	< 0.1%
0.069	1	< 0.1%
0.07	1	< 0.1%
0.236	1	< 0.1%
0.3	10	0.2%
0.551	1	< 0.1%

Value	Count	Frequency (%)
49148	1	< 0.1%
26993	1	< 0.1%
26068	4	0.1%
25969.47	1	< 0.1%
25659.47	1	< 0.1%
25220	1	< 0.1%
23819.47	1	< 0.1%
23401	1	< 0.1%
23359.47	1	< 0.1%
22326	1	< 0.1%

revt
Real number (ℝ)

Distinct	4807
Distinct (%)	99.0%
Missing	25
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	21176.691

Minimum	27.253
Maximum	521426
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	27.253
5-th percentile	923.8702
Q1	3326.445
median	8073.855
Q3	18031
95-th percentile	93525.6
Maximum	521426
Range	521398.75
Interquartile range (IQR)	14704.555

Descriptive statistics

Standard deviation	41346.83
Coefficient of variation (CV)	1.9524688
Kurtosis	44.33917
Mean	21176.691
Median Absolute Deviation (MAD)	5722.145
Skewness	5.4985157
Sum	1.0285519 × 10⁸
Variance	1.7095604 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7059	2	< 0.1%
5539	2	< 0.1%
11454	2	< 0.1%
5763	2	< 0.1%
14945	2	< 0.1%
62484	2	< 0.1%
48158	2	< 0.1%
8521	2	< 0.1%
9968	2	< 0.1%
5010	2	< 0.1%
Other values (4797)	4837	99.1%
(Missing)	25	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
27.253	1	< 0.1%
43.329	1	< 0.1%
48.631	1	< 0.1%
48.672	1	< 0.1%
60.209	1	< 0.1%
61.661	1	< 0.1%
74.962	1	< 0.1%
76.266	1	< 0.1%
76.81	1	< 0.1%
79.035	1	< 0.1%

Value	Count	Frequency (%)
521426	1	< 0.1%
511729	1	< 0.1%
496785	1	< 0.1%
483521	1	< 0.1%
482154	1	< 0.1%
479962	1	< 0.1%
474259	1	< 0.1%
467231	1	< 0.1%
444948	1	< 0.1%
433526	1	< 0.1%

seq
Real number (ℝ)

Distinct	4784
Distinct (%)	98.5%
Missing	23
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	13441.878

Minimum	-13244
Maximum	424791
Zeros	0
Zeros (%)	0.0%
Negative	178
Negative (%)	3.6%
Memory size	38.3 KiB

Quantile statistics

Minimum	-13244
5-th percentile	188.5761
Q1	1961.916
median	5047.208
Q3	11876.4
95-th percentile	52065.7
Maximum	424791
Range	438035
Interquartile range (IQR)	9914.484

Descriptive statistics

Standard deviation	29471.794
Coefficient of variation (CV)	2.1925355
Kurtosis	41.673893
Mean	13441.878
Median Absolute Deviation (MAD)	3739.008
Skewness	5.6761767
Sum	65314084
Variance	8.6858667 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10381	3	0.1%
2162	3	0.1%
-102	2	< 0.1%
7336	2	< 0.1%
5115	2	< 0.1%
6320	2	< 0.1%
2291	2	< 0.1%
3135	2	< 0.1%
11274	2	< 0.1%
2127	2	< 0.1%
Other values (4774)	4837	99.1%
(Missing)	23	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-13244	1	< 0.1%
-12688	1	< 0.1%
-12629	1	< 0.1%
-12459	1	< 0.1%
-12086	1	< 0.1%
-11785	1	< 0.1%
-11577	1	< 0.1%
-9660	1	< 0.1%
-8617	1	< 0.1%
-8446	1	< 0.1%

Value	Count	Frequency (%)
424791	1	< 0.1%
348703	1	< 0.1%
348296	1	< 0.1%
283001	1	< 0.1%
267146	1	< 0.1%
266840	1	< 0.1%
265325	1	< 0.1%
264810	1	< 0.1%
261330	1	< 0.1%
256515	1	< 0.1%

teq
Real number (ℝ)

Distinct	4782
Distinct (%)	98.4%
Missing	23
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	13782.31

Minimum	-11476
Maximum	428563
Zeros	0
Zeros (%)	0.0%
Negative	162
Negative (%)	3.3%
Memory size	38.3 KiB

Quantile statistics

Minimum	-11476
5-th percentile	238.8368
Q1	2001
median	5215.5
Q3	12187
95-th percentile	54004.8
Maximum	428563
Range	440039
Interquartile range (IQR)	10186

Descriptive statistics

Standard deviation	29886.996
Coefficient of variation (CV)	2.1685041
Kurtosis	40.550356
Mean	13782.31
Median Absolute Deviation (MAD)	3869.331
Skewness	5.5943057
Sum	66968245
Variance	8.9323256 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8063	3	0.1%
11296	2	< 0.1%
2622.9	2	< 0.1%
4714	2	< 0.1%
7088	2	< 0.1%
7235	2	< 0.1%
2075	2	< 0.1%
2541	2	< 0.1%
243	2	< 0.1%
7679	2	< 0.1%
Other values (4772)	4838	99.1%
(Missing)	23	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-11476	1	< 0.1%
-11203	1	< 0.1%
-10900	1	< 0.1%
-10739	1	< 0.1%
-10653	1	< 0.1%
-10230	1	< 0.1%
-9599	1	< 0.1%
-8446	1	< 0.1%
-8341	1	< 0.1%
-8300	1	< 0.1%

Value	Count	Frequency (%)
428563	1	< 0.1%
352500	1	< 0.1%
351954	1	< 0.1%
286359	1	< 0.1%
267146	1	< 0.1%
266840	1	< 0.1%
265325	1	< 0.1%
264810	1	< 0.1%
261330	1	< 0.1%
258627	1	< 0.1%

xad
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	1524
Distinct (%)	70.5%
Missing	2720
Missing (%)	55.7%
Infinite	0
Infinite (%)	0.0%
Mean	571.4789

Minimum	0
Maximum	11000
Zeros	7
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	0
5-th percentile	4.205
Q1	37.2
median	153
Q3	522.61975
95-th percentile	2799.9
Maximum	11000
Range	11000
Interquartile range (IQR)	485.41975

Descriptive statistics

Standard deviation	1115.1669
Coefficient of variation (CV)	1.9513701
Kurtosis	20.370478
Mean	571.4789
Median Absolute Deviation (MAD)	140.2
Skewness	3.9220123
Sum	1235537.4
Variance	1243597.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2600	10	0.2%
2500	10	0.2%
1200	10	0.2%
1600	9	0.2%
30	8	0.2%
2400	8	0.2%
98	8	0.2%
11	7	0.1%
1000	7	0.1%
1100	7	0.1%
Other values (1514)	2078	42.6%
(Missing)	2720	55.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	0.1%
0.1	1	< 0.1%
0.2	1	< 0.1%
0.3	2	< 0.1%
0.4	2	< 0.1%
0.5	2	< 0.1%
0.6	1	< 0.1%
0.8	1	< 0.1%
1	1	< 0.1%
1.1	3	0.1%

Value	Count	Frequency (%)
11000	1	< 0.1%
9729	1	< 0.1%
9345	1	< 0.1%
9315	1	< 0.1%
9236	1	< 0.1%
8576	1	< 0.1%
8290	1	< 0.1%
8200	1	< 0.1%
7617	1	< 0.1%
7243	1	< 0.1%

xrd
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	1919
Distinct (%)	67.8%
Missing	2053
Missing (%)	42.1%
Infinite	0
Infinite (%)	0.0%
Mean	888.34346

Minimum	0
Maximum	35931
Zeros	651
Zeros (%)	13.3%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	16.476
median	148.258
Q3	651
95-th percentile	5151
Maximum	35931
Range	35931
Interquartile range (IQR)	634.524

Descriptive statistics

Standard deviation	2250.3446
Coefficient of variation (CV)	2.5331921
Kurtosis	49.796168
Mean	888.34346
Median Absolute Deviation (MAD)	148.258
Skewness	5.7194273
Sum	2513123.7
Variance	5064050.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	651	13.3%
1200	5	0.1%
24	5	0.1%
376	5	0.1%
96	5	0.1%
56	5	0.1%
647	4	0.1%
1300	4	0.1%
93	4	0.1%
33	4	0.1%
Other values (1909)	2137	43.8%
(Missing)	2053	42.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	651	13.3%
0.153	1	< 0.1%
1.109	1	< 0.1%
1.582	1	< 0.1%
1.632	1	< 0.1%
2.146	1	< 0.1%
3.198	1	< 0.1%
3.3	1	< 0.1%
3.955	1	< 0.1%
4.325	1	< 0.1%

Value	Count	Frequency (%)
35931	1	< 0.1%
28837	1	< 0.1%
26018	1	< 0.1%
22620	1	< 0.1%
21419	1	< 0.1%
16876	1	< 0.1%
16625	1	< 0.1%
16217	1	< 0.1%
16085	1	< 0.1%
14726	1	< 0.1%

cik
Real number (ℝ)

Distinct	498
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	767463.36

Minimum	1800
Maximum	1932393
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	1800
5-th percentile	16741.3
Q1	96021
median	878927
Q3	1120193
95-th percentile	1613103
Maximum	1932393
Range	1930593
Interquartile range (IQR)	1024172

Descriptive statistics

Standard deviation	539146.57
Coefficient of variation (CV)	0.70250464
Kurtosis	-1.1918842
Mean	767463.36
Median Absolute Deviation (MAD)	445477
Skewness	-0.10135904
Sum	3.7467561 × 10⁹
Variance	2.9067903 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56873	11	0.2%
104169	11	0.2%
27419	11	0.2%
1123360	11	0.2%
745732	11	0.2%
1108524	11	0.2%
1285785	11	0.2%
1336920	11	0.2%
1045810	11	0.2%
764478	11	0.2%
Other values (488)	4772	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1800	10	0.2%
2488	10	0.2%
2969	10	0.2%
4127	10	0.2%
4281	5	0.1%
4447	10	0.2%
4904	10	0.2%
4962	10	0.2%
4977	10	0.2%
5272	10	0.2%

Value	Count	Frequency (%)
1932393	1	< 0.1%
1841666	10	0.2%
1821825	1	< 0.1%
1792044	10	0.2%
1783180	5	0.1%
1781335	5	0.1%
1757898	10	0.2%
1755672	5	0.1%
1754301	6	0.1%
1751788	5	0.1%

costat
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	38.3 KiB

A	4882

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	4882
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	4882	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	4882	100.0%

Most occurring characters

Value	Count	Frequency (%)
A	4882	100.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4882	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	4882	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4882	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	4882	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4882	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	4882	100.0%

dvpsp_f
Real number (ℝ)

MISSING ZEROS

Distinct	848
Distinct (%)	17.7%
Missing	93
Missing (%)	1.9%
Infinite	0
Infinite (%)	0.0%
Mean	1.2480741

Minimum	0
Maximum	46
Zeros	1110
Zeros (%)	22.7%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.08
median	0.9
Q3	1.8
95-th percentile	3.6
Maximum	46
Range	46
Interquartile range (IQR)	1.72

Descriptive statistics

Standard deviation	1.7444404
Coefficient of variation (CV)	1.3977058
Kurtosis	157.23123
Mean	1.2480741
Median Absolute Deviation (MAD)	0.84
Skewness	8.6279011
Sum	5977.0268
Variance	3.0430724
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1110	22.7%
1	57	1.2%
0.6	53	1.1%
0.2	51	1.0%
0.4	48	1.0%
0.8	44	0.9%
2	39	0.8%
1.6	39	0.8%
0.72	37	0.8%
0.04	36	0.7%
Other values (838)	3275	67.1%
(Missing)	93	1.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1110	22.7%
0.018	2	< 0.1%
0.029	1	< 0.1%
0.03	2	< 0.1%
0.04	36	0.7%
0.0425	1	< 0.1%
0.0433	1	< 0.1%
0.06	13	0.3%
0.07	1	< 0.1%
0.075	2	< 0.1%

Value	Count	Frequency (%)
46	1	< 0.1%
34.85	1	< 0.1%
30	1	< 0.1%
26.6134	1	< 0.1%
25	1	< 0.1%
18.5	1	< 0.1%
17.7051	1	< 0.1%
14.92	1	< 0.1%
13.2	1	< 0.1%
13.0638	1	< 0.1%

mkvalt
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	4478
Distinct (%)	99.9%
Missing	401
Missing (%)	8.2%
Infinite	0
Infinite (%)	0.0%
Mean	37117.961

Minimum	62.8917
Maximum	1073390.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	62.8917
5-th percentile	3291.9376
Q1	8341.6526
median	15763.961
Q3	33633.639
95-th percentile	151974.21
Maximum	1073390.5
Range	1073327.6
Interquartile range (IQR)	25291.986

Descriptive statistics

Standard deviation	70851.297
Coefficient of variation (CV)	1.9088144
Kurtosis	58.258834
Mean	37117.961
Median Absolute Deviation (MAD)	9371.0484
Skewness	6.2412538
Sum	1.6632558 × 10⁸
Variance	5.0199062 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36812.696	2	< 0.1%
19664.7	2	< 0.1%
25119.22	2	< 0.1%
23357.3515	1	< 0.1%
29372.9636	1	< 0.1%
28619.1045	1	< 0.1%
35080.2063	1	< 0.1%
19144.2318	1	< 0.1%
52819.7318	1	< 0.1%
16902.5553	1	< 0.1%
Other values (4468)	4468	91.5%
(Missing)	401	8.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
62.8917	1	< 0.1%
117.3438	1	< 0.1%
149.1244	1	< 0.1%
160.8317	1	< 0.1%
188.0294	1	< 0.1%
207.0527	1	< 0.1%
266.5571	1	< 0.1%
267.0598	1	< 0.1%
506.2756	1	< 0.1%
509.7578	1	< 0.1%

Value	Count	Frequency (%)
1073390.54	1	< 0.1%
1023856.28	1	< 0.1%
995151.5669	1	< 0.1%
921138.3192	1	< 0.1%
920224.32	1	< 0.1%
790050.0981	1	< 0.1%
757028.97	1	< 0.1%
737467.27	1	< 0.1%
729439.0252	1	< 0.1%
723558.7085	1	< 0.1%

prcc_f
Real number (ℝ)

Distinct	4077
Distinct (%)	85.4%
Missing	106
Missing (%)	2.2%
Infinite	0
Infinite (%)	0.0%
Mean	89.483715

Minimum	0.35
Maximum	3808.41
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	0.35
5-th percentile	17.62
Q1	37.85
median	61.205
Q3	96.2375
95-th percentile	226.5575
Maximum	3808.41
Range	3808.06
Interquartile range (IQR)	58.3875

Descriptive statistics

Standard deviation	141.99435
Coefficient of variation (CV)	1.5868177
Kurtosis	222.33198
Mean	89.483715
Median Absolute Deviation (MAD)	26.83
Skewness	11.871569
Sum	427374.22
Variance	20162.394
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
72.09	4	0.1%
36.11	4	0.1%
56.43	4	0.1%
19.54	4	0.1%
58.48	4	0.1%
68.56	4	0.1%
41.31	4	0.1%
76.61	4	0.1%
35.3	4	0.1%
37.74	4	0.1%
Other values (4067)	4736	97.0%
(Missing)	106	2.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.35	1	< 0.1%
0.795	1	< 0.1%
1.01	1	< 0.1%
2.4	1	< 0.1%
2.41	1	< 0.1%
2.67	1	< 0.1%
2.87	1	< 0.1%
3.51	1	< 0.1%
3.65	1	< 0.1%
3.87	1	< 0.1%

Value	Count	Frequency (%)
3808.41	1	< 0.1%
3508.22	1	< 0.1%
2436.99	1	< 0.1%
2053.73	1	< 0.1%
1847.84	1	< 0.1%
1737.74	1	< 0.1%
1722.42	1	< 0.1%
1669	1	< 0.1%
1643	1	< 0.1%
1501.97	1	< 0.1%

gsector
Real number (ℝ)

Distinct	11
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.353748

Minimum	10
Maximum	60
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	10
5-th percentile	15
Q1	20
median	35
Q3	45
95-th percentile	60
Maximum	60
Range	50
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	13.587538
Coefficient of variation (CV)	0.39551836
Kurtosis	-0.87781663
Mean	34.353748
Median Absolute Deviation (MAD)	10
Skewness	0.09908931
Sum	167715
Variance	184.6212
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
40	734	15.0%
20	724	14.8%
45	622	12.7%
35	613	12.6%
25	529	10.8%
30	363	7.4%
55	290	5.9%
60	289	5.9%
15	281	5.8%
10	226	4.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	226	4.6%
15	281	5.8%
20	724	14.8%
25	529	10.8%
30	363	7.4%
35	613	12.6%
40	734	15.0%
45	622	12.7%
50	211	4.3%
55	290	5.9%

Value	Count	Frequency (%)
60	289	5.9%
55	290	5.9%
50	211	4.3%
45	622	12.7%
40	734	15.0%
35	613	12.6%
30	363	7.4%
25	529	10.8%
20	724	14.8%
15	281	5.8%

naics
Real number (ℝ)

Distinct	206
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	385438.06

Minimum	42
Maximum	999977
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	38.3 KiB

Quantile statistics

Minimum	42
5-th percentile	2211
Q1	325412
median	339113
Q3	522210
95-th percentile	561710
Maximum	999977
Range	999935
Interquartile range (IQR)	196798

Descriptive statistics

Standard deviation	177729.88
Coefficient of variation (CV)	0.46111141
Kurtosis	0.52549435
Mean	385438.06
Median Absolute Deviation (MAD)	172097
Skewness	-0.56581976
Sum	1.8817086 × 10⁹
Variance	3.1587912 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
522110	188	3.9%
334413	168	3.4%
531120	153	3.1%
22111	140	2.9%
2211	120	2.5%
524126	110	2.3%
325412	109	2.2%
2111	100	2.0%
518210	96	2.0%
531110	86	1.8%
Other values (196)	3612	74.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
42	10	0.2%
111	5	0.1%
315	19	0.4%
321	10	0.2%
325	10	0.2%
423	10	0.2%
621	10	0.2%
2111	100	2.0%
2211	120	2.5%
3113	10	0.2%

Value	Count	Frequency (%)
999977	20	0.4%
812331	10	0.2%
722513	40	0.8%
722511	20	0.4%
721120	30	0.6%
721110	20	0.4%
713210	6	0.1%
711320	10	0.2%
622110	20	0.4%
621511	20	0.4%

Auto

Heatmap
Table

	gvkey	fyear	fyr	act	at	bkvlps	capx	ceql	csho	dltt	dt	dvp	ebitda	emp	lct	lt	ni	ppegt	pstkl	revt	seq	teq	xad	xrd	cik	dvpsp_f	mkvalt	prcc_f	gsector	naics
gvkey	1.000	0.015	0.085	-0.287	-0.315	-0.055	-0.298	-0.281	-0.335	-0.290	-0.252	-0.055	-0.342	-0.322	-0.329	-0.313	-0.284	-0.379	-0.064	-0.347	-0.281	-0.277	-0.312	-0.226	0.666	-0.254	-0.263	0.084	0.112	0.250
fyear	0.015	1.000	0.064	0.121	0.156	0.129	0.098	0.118	0.052	0.211	0.222	0.018	0.156	0.067	0.158	0.160	0.142	0.112	0.014	0.114	0.118	0.119	0.103	0.074	0.027	0.212	0.290	0.360	0.000	-0.000
fyr	0.085	0.064	1.000	-0.064	0.136	0.174	-0.023	0.080	-0.028	0.177	0.133	0.171	0.046	-0.148	-0.006	0.149	-0.022	0.067	0.144	-0.058	0.084	0.091	-0.064	-0.000	0.034	0.028	-0.004	0.031	0.015	0.060
act	-0.287	0.121	-0.064	1.000	0.826	0.196	0.613	0.712	0.739	0.599	0.645	0.067	0.814	0.662	0.900	0.787	0.707	0.589	0.060	0.860	0.711	0.711	0.654	0.525	-0.178	0.340	0.762	0.085	-0.014	-0.102
at	-0.315	0.156	0.136	0.826	1.000	0.396	0.567	0.869	0.748	0.837	0.840	0.327	0.881	0.536	0.903	0.975	0.695	0.779	0.301	0.784	0.870	0.875	0.621	0.401	-0.174	0.363	0.742	0.003	0.078	-0.008
bkvlps	-0.055	0.129	0.174	0.196	0.396	1.000	0.103	0.561	-0.107	0.219	0.186	0.181	0.264	0.040	0.196	0.313	0.233	0.227	0.166	0.186	0.561	0.554	0.098	0.003	-0.006	0.255	0.175	0.430	0.035	-0.013
capx	-0.298	0.098	-0.023	0.613	0.567	0.103	1.000	0.507	0.552	0.577	0.596	-0.054	0.713	0.562	0.716	0.551	0.479	0.954	-0.048	0.682	0.502	0.511	0.617	0.438	-0.107	0.208	0.580	0.025	-0.215	-0.377
ceql	-0.281	0.118	0.080	0.712	0.869	0.561	0.507	1.000	0.706	0.656	0.626	0.282	0.792	0.441	0.708	0.763	0.663	0.659	0.261	0.680	0.999	0.996	0.543	0.424	-0.152	0.296	0.707	0.006	0.080	-0.076
csho	-0.335	0.052	-0.028	0.739	0.748	-0.107	0.552	0.706	1.000	0.659	0.651	0.198	0.787	0.547	0.742	0.701	0.637	0.661	0.174	0.716	0.705	0.709	0.617	0.493	-0.209	0.174	0.732	-0.321	0.050	-0.098
dltt	-0.290	0.211	0.177	0.599	0.837	0.219	0.577	0.656	0.659	1.000	0.997	0.291	0.806	0.480	0.723	0.869	0.558	0.783	0.261	0.678	0.656	0.667	0.565	0.205	-0.142	0.391	0.659	0.003	0.061	-0.056
dt	-0.252	0.222	0.133	0.645	0.840	0.186	0.596	0.626	0.651	0.997	1.000	0.221	0.798	0.514	0.738	0.880	0.554	0.768	0.170	0.691	0.626	0.635	0.573	0.215	-0.137	0.374	0.676	0.046	-0.036	-0.005
dvp	-0.055	0.018	0.171	0.067	0.327	0.181	-0.054	0.282	0.198	0.291	0.221	1.000	0.242	-0.037	0.126	0.318	0.117	0.224	0.845	0.042	0.300	0.301	0.117	-0.140	-0.048	0.142	0.120	-0.105	0.270	0.155
ebitda	-0.342	0.156	0.046	0.814	0.881	0.264	0.713	0.792	0.787	0.806	0.798	0.242	1.000	0.678	0.854	0.849	0.840	0.796	0.221	0.883	0.792	0.794	0.708	0.428	-0.200	0.449	0.858	0.117	-0.003	-0.062
emp	-0.322	0.067	-0.148	0.662	0.536	0.040	0.562	0.441	0.547	0.480	0.514	-0.037	0.678	1.000	0.688	0.549	0.584	0.562	-0.035	0.817	0.435	0.431	0.643	0.286	-0.225	0.175	0.579	0.051	-0.254	0.012
lct	-0.329	0.158	-0.006	0.900	0.903	0.196	0.716	0.708	0.742	0.723	0.738	0.126	0.854	0.688	1.000	0.911	0.693	0.702	0.106	0.889	0.707	0.712	0.710	0.431	-0.179	0.411	0.758	0.069	0.013	-0.074
lt	-0.313	0.160	0.149	0.787	0.975	0.313	0.551	0.763	0.701	0.869	0.880	0.318	0.849	0.549	0.911	1.000	0.654	0.765	0.291	0.772	0.763	0.770	0.606	0.351	-0.177	0.368	0.696	0.003	0.064	0.018
ni	-0.284	0.142	-0.022	0.707	0.695	0.233	0.479	0.663	0.637	0.558	0.554	0.117	0.840	0.584	0.693	0.654	1.000	0.548	0.106	0.735	0.661	0.653	0.618	0.373	-0.197	0.371	0.786	0.210	-0.044	-0.037
ppegt	-0.379	0.112	0.067	0.589	0.779	0.227	0.954	0.659	0.661	0.783	0.768	0.224	0.796	0.562	0.702	0.765	0.548	1.000	0.202	0.742	0.660	0.672	0.669	0.307	-0.192	0.419	0.626	-0.016	-0.111	-0.314
pstkl	-0.064	0.014	0.144	0.060	0.301	0.166	-0.048	0.261	0.174	0.261	0.170	0.845	0.221	-0.035	0.106	0.291	0.106	0.202	1.000	0.028	0.280	0.280	0.115	-0.126	-0.055	0.153	0.115	-0.100	0.309	0.115
revt	-0.347	0.114	-0.058	0.860	0.784	0.186	0.682	0.680	0.716	0.678	0.691	0.042	0.883	0.817	0.889	0.772	0.735	0.742	0.028	1.000	0.675	0.678	0.753	0.374	-0.212	0.304	0.746	0.049	-0.200	-0.141
seq	-0.281	0.118	0.084	0.711	0.870	0.561	0.502	0.999	0.705	0.656	0.626	0.300	0.792	0.435	0.707	0.763	0.661	0.660	0.280	0.675	1.000	0.997	0.540	0.418	-0.150	0.299	0.704	0.005	0.087	-0.070
teq	-0.277	0.119	0.091	0.711	0.875	0.554	0.511	0.996	0.709	0.667	0.635	0.301	0.794	0.431	0.712	0.770	0.653	0.672	0.280	0.678	0.997	1.000	0.544	0.414	-0.145	0.302	0.702	-0.002	0.080	-0.072
xad	-0.312	0.103	-0.064	0.654	0.621	0.098	0.617	0.543	0.617	0.565	0.573	0.117	0.708	0.643	0.710	0.606	0.618	0.669	0.115	0.753	0.540	0.544	1.000	0.324	-0.229	0.337	0.682	0.078	0.009	-0.133
xrd	-0.226	0.074	-0.000	0.525	0.401	0.003	0.438	0.424	0.493	0.205	0.215	-0.140	0.428	0.286	0.431	0.351	0.373	0.307	-0.126	0.374	0.418	0.414	0.324	1.000	-0.141	-0.011	0.494	-0.015	0.048	-0.343
cik	0.666	0.027	0.034	-0.178	-0.174	-0.006	-0.107	-0.152	-0.209	-0.142	-0.137	-0.048	-0.200	-0.225	-0.179	-0.177	-0.197	-0.192	-0.055	-0.212	-0.150	-0.145	-0.229	-0.141	1.000	-0.219	-0.166	0.041	0.074	0.124
dvpsp_f	-0.254	0.212	0.028	0.340	0.363	0.255	0.208	0.296	0.174	0.391	0.374	0.142	0.449	0.175	0.411	0.368	0.371	0.419	0.153	0.304	0.299	0.302	0.337	-0.011	-0.219	1.000	0.385	0.324	-0.029	-0.097
mkvalt	-0.263	0.290	-0.004	0.762	0.742	0.175	0.580	0.707	0.732	0.659	0.676	0.120	0.858	0.579	0.758	0.696	0.786	0.626	0.115	0.746	0.704	0.702	0.682	0.494	-0.166	0.385	1.000	0.333	-0.024	-0.052
prcc_f	0.084	0.360	0.031	0.085	0.003	0.430	0.025	0.006	-0.321	0.003	0.046	-0.105	0.117	0.051	0.069	0.003	0.210	-0.016	-0.100	0.049	0.005	-0.002	0.078	-0.015	0.041	0.324	0.333	1.000	-0.103	0.068
gsector	0.112	0.000	0.015	-0.014	0.078	0.035	-0.215	0.080	0.050	0.061	-0.036	0.270	-0.003	-0.254	0.013	0.064	-0.044	-0.111	0.309	-0.200	0.087	0.080	0.009	0.048	0.074	-0.029	-0.024	-0.103	1.000	0.277
naics	0.250	-0.000	0.060	-0.102	-0.008	-0.013	-0.377	-0.076	-0.098	-0.056	-0.005	0.155	-0.062	0.012	-0.074	0.018	-0.037	-0.314	0.115	-0.141	-0.070	-0.072	-0.133	-0.343	0.124	-0.097	-0.052	0.068	0.277	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	gvkey	datadate	fyear	indfmt	consol	popsrc	datafmt	tic	cusip	conm	curcd	fyr	act	at	bkvlps	capx	ceql	csho	dltt	dt	ebitda	emp	lct	lt	ni	ppegt	revt	seq	teq	xad	xrd	cik	costat	dvpsp_f	mkvalt	prcc_f	gsector	naics
0	1045	2010-12-31	2010	INDL	C	D	STD	AAL	02376R102	AMERICAN AIRLINES GROUP INC	USD	12	6838.0	25088.0	-11.8309	1962.0	-3945.0	333.450	9253.0	11136.0	1303.0	78.25	8780.0	29033.0	-471.0	26717.0	22170.0	-3945.0	-3945.0	165.0	NaN	6201	A	0.0	2597.5755	7.790	20	481111
1	1045	2011-12-31	2011	INDL	C	D	STD	AAL	02376R102	AMERICAN AIRLINES GROUP INC	USD	12	6757.0	23848.0	-21.2099	1610.0	-7111.0	335.268	6702.0	8220.0	695.0	80.10	8630.0	30959.0	-1979.0	24854.0	24022.0	-7111.0	-7111.0	186.0	NaN	6201	A	0.0	117.3438	0.350	20	481111
2	1045	2012-12-31	2012	INDL	C	D	STD	AAL	02376R102	AMERICAN AIRLINES GROUP INC	USD	12	7072.0	23510.0	-23.8210	1888.0	-7987.0	335.292	7116.0	8535.0	1434.0	77.75	9304.0	31497.0	-1876.0	24233.0	24855.0	-7987.0	-7987.0	153.0	NaN	6201	A	0.0	266.5571	0.795	20	481111
3	1045	2013-12-31	2013	INDL	C	D	STD	AAL	02376R102	AMERICAN AIRLINES GROUP INC	USD	12	14323.0	42278.0	-10.4608	3114.0	-2731.0	261.069	15353.0	16799.0	2956.0	110.40	13806.0	45009.0	-1834.0	30392.0	26712.0	-2731.0	-2731.0	166.0	NaN	6201	A	0.0	6591.9923	25.250	20	481111
4	1045	2014-12-31	2014	INDL	C	D	STD	AAL	02376R102	AMERICAN AIRLINES GROUP INC	USD	12	12112.0	43771.0	2.8976	5311.0	2021.0	697.475	16196.0	17904.0	6585.0	113.30	13435.0	41750.0	2882.0	35343.0	42650.0	2021.0	2021.0	100.0	NaN	6201	A	0.2	37405.5843	53.630	20	481111
5	1045	2015-12-31	2015	INDL	C	D	STD	AAL	02376R102	AMERICAN AIRLINES GROUP INC	USD	12	9985.0	48415.0	9.0215	6151.0	5635.0	624.622	18330.0	20561.0	8891.0	118.50	13605.0	42780.0	7610.0	40654.0	40990.0	5635.0	5635.0	110.0	NaN	6201	A	0.4	26452.7417	42.350	20	481111
6	1045	2016-12-31	2016	INDL	C	D	STD	AAL	02376R102	AMERICAN AIRLINES GROUP INC	USD	12	10324.0	51274.0	7.4612	5731.0	3785.0	507.294	22489.0	24344.0	7833.0	122.30	13872.0	47489.0	2676.0	45353.0	40180.0	3785.0	3785.0	116.0	NaN	6201	A	0.4	23685.5569	46.690	20	481111
7	1045	2017-12-31	2017	INDL	C	D	STD	AAL	02376R102	AMERICAN AIRLINES GROUP INC	USD	12	9146.0	51396.0	8.2564	5971.0	3926.0	475.508	22511.0	25065.0	6809.0	126.60	14964.0	47470.0	1919.0	49802.0	42207.0	3926.0	3926.0	135.0	NaN	6201	A	0.4	24740.6812	52.030	20	481111
8	1045	2018-12-31	2018	INDL	C	D	STD	AAL	02376R102	AMERICAN AIRLINES GROUP INC	USD	12	8637.0	60580.0	-0.3669	3745.0	-169.0	460.611	29081.0	34029.0	5606.0	128.90	18096.0	60749.0	1412.0	60692.0	44541.0	-169.0	-169.0	128.0	NaN	6201	A	0.4	14790.2192	32.110	20	481111
9	1045	2019-12-31	2019	INDL	C	D	STD	AAL	02376R102	AMERICAN AIRLINES GROUP INC	USD	12	8206.0	59995.0	-0.2756	4268.0	-118.0	428.203	28875.0	33444.0	6024.0	133.70	18311.0	60113.0	1686.0	62391.0	45768.0	-118.0	-118.0	129.0	NaN	6201	A	0.4	12280.8620	28.680	20	481111

	gvkey	datadate	fyear	indfmt	consol	popsrc	datafmt	tic	cusip	conm	curcd	fyr	act	at	bkvlps	capx	ceql	csho	dltt	dt	ebitda	emp	lct	lt	ni	ppegt	revt	seq	teq	xad	xrd	cik	costat	dvpsp_f	mkvalt	prcc_f	gsector	naics
4872	294524	2019-12-31	2019	INDL	C	D	STD	LYB	N53745100	LYONDELLBASELL INDUSTRIES NV	USD	12	9510.0	30435.0	24.1216	2694.0	8044.0	333.477	12830.0	13106.0	5544.0	19.1	5198.0	22256.0	3390.0	22728.0	34727.0	8044.0	8063.0	NaN	111.0	1489393	A	4.15	31506.9070	94.48	15	325220
4873	316056	2011-12-31	2011	INDL	C	D	STD	ALLE	G0176J109	ALLEGION PLC	USD	12	961.7	2036.2	NaN	25.5	1413.8	NaN	3.5	4.9	405.3	NaN	374.5	600.4	218.1	558.0	2021.2	1413.8	1435.8	NaN	38.9	1579241	A	NaN	NaN	NaN	20	332510
4874	316056	2012-12-31	2012	INDL	C	D	STD	ALLE	G0176J109	ALLEGION PLC	USD	12	909.9	1983.8	NaN	19.6	1343.2	NaN	2.8	3.7	419.9	7.6	382.7	617.6	219.6	586.8	2046.6	1343.2	1366.2	NaN	38.2	1579241	A	NaN	NaN	NaN	20	332510
4875	316056	2013-12-31	2013	INDL	C	D	STD	ALLE	G0176J109	ALLEGION PLC	USD	12	923.2	1979.9	-0.9039	20.2	-86.8	96.029	1272.0	1302.0	409.0	8.0	490.5	2035.6	31.0	569.2	2093.5	-86.8	-55.7	NaN	39.6	1579241	A	0.00	4243.5215	44.19	20	332510
4876	316056	2014-12-31	2014	INDL	C	D	STD	ALLE	G0176J109	ALLEGION PLC	USD	12	973.8	2015.9	-0.0501	51.5	-4.8	95.831	1215.0	1215.0	439.3	8.5	531.3	1997.4	175.2	586.8	2118.3	-4.8	18.5	NaN	43.3	1579241	A	0.32	5314.7873	55.46	20	332510
4877	316056	2015-12-31	2015	INDL	C	D	STD	ALLE	G0176J109	ALLEGION PLC	USD	12	735.1	2285.3	0.2667	35.2	25.6	95.991	1479.8	1479.8	444.1	9.4	447.1	2255.6	153.9	616.5	2068.1	25.6	29.7	NaN	45.2	1579241	A	0.40	6327.7267	65.92	20	332510
4878	316056	2016-12-31	2016	INDL	C	D	STD	ALLE	G0176J109	ALLEGION PLC	USD	12	829.3	2247.4	1.1892	42.5	113.3	95.274	1415.6	1463.8	490.0	9.4	429.6	2131.0	229.1	640.4	2238.0	113.3	116.4	NaN	47.3	1579241	A	0.48	6097.5360	64.00	20	332510
4879	316056	2017-12-31	2017	INDL	C	D	STD	ALLE	G0176J109	ALLEGION PLC	USD	12	1032.7	2542.0	4.2246	49.3	401.6	95.062	1442.3	1477.3	567.3	10.0	460.8	2136.5	273.3	707.9	2408.2	401.6	405.5	NaN	48.3	1579241	A	0.64	7563.1327	79.56	20	332510
4880	316056	2018-12-31	2018	INDL	C	D	STD	ALLE	G0176J109	ALLEGION PLC	USD	12	931.6	2810.2	6.8789	49.1	651.0	94.637	1409.5	1444.8	619.0	11.0	520.8	2156.2	434.9	748.8	2731.7	651.0	654.0	NaN	54.4	1579241	A	0.84	7543.5153	79.71	20	332510
4881	316056	2019-12-31	2019	INDL	C	D	STD	ALLE	G0176J109	ALLEGION PLC	USD	12	1001.8	2967.2	8.1683	65.6	757.4	92.724	1483.2	1509.1	651.3	11.0	507.0	2206.8	401.8	867.4	2854.0	757.4	760.4	NaN	54.7	1579241	A	1.08	11547.8470	124.54	20	332510

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block